Exploratory Data Analysis

Go to Home Page
  • Total Spending per Month
  • Spend per Category per Month
  • Amount per Person
  • Individual Expenses
  • Tables
  • Treemap of Categories


Mobile users!
Landscape mode is your friend

Summary

Total Amount spent: $20,230.16

Total Amount per Person: $6,743.39

Date Range: November 2020 - February 2025

Data Assumptions¶

As part of switching between electric companies, June of 2023 charged an unusally high amount after shortchanging the prior month. At this point in the analysis, in just a few short plots, I will move some of that money from June to May of 2023 to more accurately reflect what billing should have been.

At the same point, I will consolidate "Pepco" and "CleanChoice" into one creatively-named value, "Electric". Accounting wizardry.

In the same spirit of data fidelity to truthiness, I manually updated December 2023 through April 2024, to account for the weird stretch where the utility company only billed $19/month and created a giant backlog of debt that had to be paid off.

Some days, you're just on hold with the Electric company.

Total Spending per Month¶

Back to Top

Bill per Category per Month¶

Back to Top

This is the only time you'll see the Pepco / CleanChoice data. After this, they'll be consolidated into "Electric"

Data Change¶

Here is where I consolidate CleanChoice and Pepco into "Electric". I also pull a sneaky trick and move $143.50 from June 2023 to May 2023. See intro.

Bill per Person¶

Back to Top

Out[18]:
Amount Amount_per_person
count 52.000000 52.000000
mean 389.041538 129.680513
std 79.642766 26.547589
min 194.000000 64.666667
25% 339.865000 113.288333
50% 390.305000 130.101667
75% 425.167500 141.722500
max 579.930000 193.310000

Individual Expenses¶

Back to Top

Tables¶

Back to Top

Treemap of Categories¶

Back to Top